User Defined Fields (UDFs)
Users may define their own fields in certain areas of Ready Pay, including the Company, Employee, Pay Items, Department, Cost Centre, Superfund, Employment Condition, Templates, Positions and Position Events screens.
UDFs are also available in the Data Explorer and can therefore be used for reporting, sorting, grouping and totalling.
User Defined Fields are 'multi-user' - meaning that fields added will be seen by all users.
They are also cross-company, which means that you can publish the field to one or more companies.
UDFs can be selected in the grid of their parent screen. Screens that contain this feature are: States, Pay Items, Templates, Cost Centres, Departments, Super Funds, Workplaces, Employment Conditions, Work Patterns, HR - Positions (top level node only), OHS Policies & Procedures, OHS Personnel, OHS Committees, OHS Incidents, OHS Hazards, OHS Audits & Meetings and OHS Plant & Equipment.
Any UDFs defined for any of these screen can be selected via the Field Chooser in Data Explorer and saved in any default or custom views for that screen.
To be able to use this facility and create a User Defined Field, the users
To create a User Defined Field (UDF):
- Click on the User Defined Fields tab in the area you want the UDF, e.g. Employee Details, States etc.
- Click on the UDF Designer button
.
The UDF designer will open. - Click the Add UDF button
- In the Define Field Caption line, enter the caption/title/field name that you want to use for the UDF.
- Select the Data Type from the drop-down list. The available data types include:
Data Type | Explanation |
Integer | This requires the user to enter a whole number value in this field. You are able to set a default value for the field. |
Float |
This requires the user to enter a value, which may have up to four decimal places. Once a value has been entered, you may alter the display format of the field: click on the Mask button.
|
String | This requires the user to enter a text string. |
Checkbox | This requires the user to select a yes/ no or true/false response. |
|
|
Datetime | This requires the user to select a date and time from the calendar. |
Time | This requires the user to use the up and down arrows to select a time. |
List | This creates a user defined This will drop down with a list of options from which the user must select one which will then appear in the field. You are also able to enter a default value |
Date | This requires the user to select a Date from the calendar. |
- Enter a value in the Set default value for new records to field, to set a default value that will be applied to all new records
- Enter a value in the Set default value for new records to field, to set a default value that will be applied to all new records.
- If you want to change all existing records to a specific value, enter the value in the Initialise ALL existing records to field and then click on the Go button.
You will then see a system message that asks if you are sure that you want to initialise all existing records to the chosen value. If you are sure, click Yes, if not, click No to return to the UDF Designer. - Click on the Save UDF button
.
- Repeat the process for all the new fields you wish to add.
- Once you have created all of the necessary fields, click on the Finishbutton
.
- You can customise and move the UDF's around to suit your needs by clicking on the Layout button
.
This will open the Customization screen. - You can click on the fields and drag them into position or move them into place using the tree view on the Customization screen.
- Once you have the UDF screen set up as required, click on the Publish Layout button, at the bottom right of the screen, as shown below.
Select the company/ies that you wish the layout to be seen in.
Remember that initialising a value across all records, means that you will set all of the existing instances of that
UDF to the value you enter at that point.
UDF's are global and are available to all companies, but will only be published/viewable in those selected. The UDF's that you create will also be available in the Data Explorer and can be used for reporting, sorting, totalling, etc.
Creating a user defined drop-down list:
- Once you have entered the field caption, click on the drop-down arrow in the Data Type field and select List.
The Lookup Table and Default Value fields will become available.
- Select a pre-saved lookup table from the drop-down list or select <<Add New>>to create a new one.
- Enter a name for the new lookup table in the Lookup Name field.
- Click on the Add New button
to add a description for a look up item . Each description that you add will become an option in that drop-down list.
- To add another description, click Apply and then click on the Add New Button again.
- Once you have added all of the descriptions you require, click OK to save the lookup table descriptions.
- If you want to set a default value for the lookup table, click on the drop-down arrow in the Default field and select the chosen value from the drop-down list. This will set the default value for any newly created records.
UDF Limits
In each area where you define UDF's there are limits to the number of UDF's you may create. These limits depend on the Data Type combinations used.
- You can create up to 20 x List, String and Checkbox UDF's combined.
For example, you could have 5 x List, 12 x String and 3 x Checkbox, or any other combination, up to a maximum of 20.
- You can create up to 9 x Date, Time and Datetime UDF's combined.
For example, you could have 3 x Date, 3 x Time and 3 x Datetime, or any other combination, up to a maximum of 9.
- You can create up to 9 x Integer and Float UDF's combined.
For example, you could have 5 x Integer and 4 x Float, or any other combination, up to a maximum of 9.
These are not the overall total UDF limits. Each of the specified limits apply to every area, i.e. wherever you find a UDF tab.